DataFrame info

Dataset statistics

Number of variables	18
Number of observations	2000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	59
Duplicate rows (%)	2.9%
Total size in memory	267.7 KiB
Average record size in memory	137.1 B

Variable types

Categorical	4
Numeric	13
Boolean	1

Alerts

Dataset has 59 (2.9%) duplicate rows	Duplicates
`artist` has a high cardinality: 835 distinct values	High cardinality
`song` has a high cardinality: 1879 distinct values	High cardinality
`genre` has a high cardinality: 59 distinct values	High cardinality
`energy` is highly correlated with `loudness` and 2 other fields	High correlation
`loudness` is highly correlated with `energy` and 2 other fields	High correlation
`explicit` is highly correlated with `speechiness` and 1 other fields	High correlation
`genre` is highly correlated with `explicit` and 3 other fields	High correlation
`speechiness` is highly correlated with `explicit`	High correlation
`acousticness` is highly correlated with `energy` and 1 other fields	High correlation
`instrumentalness` is highly correlated with `genre`	High correlation
`song` is uniformly distributed	Uniform
`popularity` has 126 (6.3%) zeros	Zeros
`key` has 198 (9.9%) zeros	Zeros
`instrumentalness` has 1087 (54.4%) zeros	Zeros

Reproduction

Analysis started	2022-11-14 17:07:51.083575
Analysis finished	2022-11-14 17:09:06.252533
Duration	1 minute and 15.17 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

artist
Categorical

HIGH CARDINALITY

Distinct	835
Distinct (%)	41.8%
Missing	0
Missing (%)	0.0%
Memory size	15.8 KiB

Rihanna	25
Drake	23
Eminem	21
Calvin Harris	20
Britney Spears	19
Other values (830)	1892

Length

Max length	41
Median length	22
Mean length	9.9915
Min length	2

Characters and Unicode

Total characters	19983
Distinct characters	84
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	494 ?
Unique (%)	24.7%

Sample

1st row	Britney Spears
2nd row	blink-182
3rd row	Faith Hill
4th row	Bon Jovi
5th row	*NSYNC

Common Values

Value	Count	Frequency (%)
Rihanna	25	1.2%
Drake	23	1.1%
Eminem	21	1.1%
Calvin Harris	20	1.0%
Britney Spears	19	0.9%
David Guetta	18	0.9%
Chris Brown	17	0.9%
Kanye West	17	0.9%
Beyoncé	16	0.8%
Taylor Swift	16	0.8%
Other values (825)	1808	90.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	85	2.4%
rihanna	25	0.7%
david	25	0.7%
lil	23	0.7%
drake	23	0.7%
	22	0.6%
justin	22	0.6%
eminem	21	0.6%
j	21	0.6%
calvin	20	0.6%
Other values (1215)	3226	91.8%

Most occurring characters

Value	Count	Frequency (%)
e	1744	8.7%
a	1709	8.6%
	1513	7.6%
i	1388	6.9%
n	1181	5.9%
r	1038	5.2%
o	973	4.9%
l	958	4.8%
s	845	4.2%
t	649	3.2%
Other values (74)	7985	40.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14349	71.8%
Uppercase Letter	3821	19.1%
Space Separator	1513	7.6%
Other Punctuation	150	0.8%
Decimal Number	94	0.5%
Dash Punctuation	50	0.3%
Currency Symbol	4	< 0.1%
Math Symbol	1	< 0.1%
Final Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1744	12.2%
a	1709	11.9%
i	1388	9.7%
n	1181	8.2%
r	1038	7.2%
o	973	6.8%
l	958	6.7%
s	845	5.9%
t	649	4.5%
y	508	3.5%
Other values (21)	3356	23.4%

Uppercase Letter

Value	Count	Frequency (%)
S	308	8.1%
C	282	7.4%
B	281	7.4%
M	269	7.0%
T	259	6.8%
D	251	6.6%
A	234	6.1%
J	224	5.9%
L	213	5.6%
P	187	4.9%
Other values (19)	1313	34.4%

Decimal Number

Value	Count	Frequency (%)
5	27	28.7%
2	17	18.1%
3	13	13.8%
1	11	11.7%
0	10	10.6%
9	5	5.3%
4	4	4.3%
6	3	3.2%
7	2	2.1%
8	2	2.1%

Other Punctuation

Value	Count	Frequency (%)
.	77	51.3%
'	24	16.0%
!	21	14.0%
&	19	12.7%
*	4	2.7%
"	2	1.3%
\	1	0.7%
/	1	0.7%
,	1	0.7%

Space Separator

Value	Count	Frequency (%)
	1513	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	50	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	4	100.0%

Math Symbol

Value	Count	Frequency (%)
+	1	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18170	90.9%
Common	1813	9.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1744	9.6%
a	1709	9.4%
i	1388	7.6%
n	1181	6.5%
r	1038	5.7%
o	973	5.4%
l	958	5.3%
s	845	4.7%
t	649	3.6%
y	508	2.8%
Other values (50)	7177	39.5%

Common

Value	Count	Frequency (%)
	1513	83.5%
.	77	4.2%
-	50	2.8%
5	27	1.5%
'	24	1.3%
!	21	1.2%
&	19	1.0%
2	17	0.9%
3	13	0.7%
1	11	0.6%
Other values (14)	41	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19950	99.8%
None	32	0.2%
Punctuation	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1744	8.7%
a	1709	8.6%
	1513	7.6%
i	1388	7.0%
n	1181	5.9%
r	1038	5.2%
o	973	4.9%
l	958	4.8%
s	845	4.2%
t	649	3.3%
Other values (65)	7952	39.9%

None

Value	Count	Frequency (%)
é	19	59.4%
ë	3	9.4%
ó	3	9.4%
ý	2	6.2%
Ø	2	6.2%
Ö	1	3.1%
í	1	3.1%
Ü	1	3.1%

Punctuation

Value	Count	Frequency (%)
’	1	100.0%

song
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	1879
Distinct (%)	94.0%
Missing	0
Missing (%)	0.0%
Memory size	15.8 KiB

Sorry	5
Don't	3
Closer	3
Breathe	3
It's My Life	3
Other values (1874)	1983

Length

Max length	114
Median length	64
Mean length	17.6115
Min length	1

Characters and Unicode

Total characters	35223
Distinct characters	107
Distinct categories	13 ?
Distinct scripts	4 ?
Distinct blocks	5 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1770 ?
Unique (%)	88.5%

Sample

1st row	Oops!...I Did It Again
2nd row	All The Small Things
3rd row	Breathe
4th row	It's My Life
5th row	Bye Bye Bye

Common Values

Value	Count	Frequency (%)
Sorry	5	0.2%
Don't	3	0.1%
Closer	3	0.1%
Breathe	3	0.1%
It's My Life	3	0.1%
Rise	3	0.1%
Mercy	3	0.1%
Faded	3	0.1%
Higher	3	0.1%
I Like It	3	0.1%
Other values (1869)	1968	98.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
feat	287	4.2%
	266	3.9%
the	174	2.5%
you	159	2.3%
me	130	1.9%
i	105	1.5%
it	99	1.4%
love	97	1.4%
radio	95	1.4%
edit	84	1.2%
Other values (2157)	5404	78.3%

Most occurring characters

Value	Count	Frequency (%)
	4900	13.9%
e	3089	8.8%
a	2152	6.1%
o	2135	6.1%
t	1828	5.2%
i	1800	5.1%
n	1512	4.3%
r	1307	3.7%
l	997	2.8%
s	920	2.6%
Other values (97)	14583	41.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	22029	62.5%
Uppercase Letter	6291	17.9%
Space Separator	4900	13.9%
Other Punctuation	825	2.3%
Close Punctuation	412	1.2%
Open Punctuation	412	1.2%
Dash Punctuation	201	0.6%
Decimal Number	123	0.3%
Other Letter	13	< 0.1%
Currency Symbol	10	< 0.1%
Other values (3)	7	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	3089	14.0%
a	2152	9.8%
o	2135	9.7%
t	1828	8.3%
i	1800	8.2%
n	1512	6.9%
r	1307	5.9%
l	997	4.5%
s	920	4.2%
h	844	3.8%
Other values (20)	5445	24.7%

Uppercase Letter

Value	Count	Frequency (%)
M	485	7.7%
T	480	7.6%
S	478	7.6%
L	438	7.0%
I	385	6.1%
B	368	5.8%
W	334	5.3%
R	330	5.2%
D	309	4.9%
A	296	4.7%
Other values (19)	2388	38.0%

Other Punctuation

Value	Count	Frequency (%)
.	378	45.8%
'	223	27.0%
&	86	10.4%
,	52	6.3%
"	27	3.3%
?	17	2.1%
!	16	1.9%
*	11	1.3%
/	9	1.1%
#	2	0.2%
Other values (4)	4	0.5%

Other Letter

Value	Count	Frequency (%)
스	1	7.7%
강	1	7.7%
남	1	7.7%
타	1	7.7%
ト	1	7.7%
ッ	1	7.7%
ィ	1	7.7%
デ	1	7.7%
エ	1	7.7%
オ	1	7.7%
Other values (3)	3	23.1%

Decimal Number

Value	Count	Frequency (%)
2	35	28.5%
1	23	18.7%
0	19	15.4%
3	12	9.8%
6	7	5.7%
7	7	5.7%
8	6	4.9%
9	5	4.1%
4	5	4.1%
5	4	3.3%

Close Punctuation

Value	Count	Frequency (%)
)	404	98.1%
]	8	1.9%

Open Punctuation

Value	Count	Frequency (%)
(	404	98.1%
[	8	1.9%

Other Symbol

Value	Count	Frequency (%)
®	1	50.0%
°	1	50.0%

Space Separator

Value	Count	Frequency (%)
	4900	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	201	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	10	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	3	100.0%

Math Symbol

Value	Count	Frequency (%)
+	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	28320	80.4%
Common	6890	19.6%
Katakana	8	< 0.1%
Hangul	5	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	3089	10.9%
a	2152	7.6%
o	2135	7.5%
t	1828	6.5%
i	1800	6.4%
n	1512	5.3%
r	1307	4.6%
l	997	3.5%
s	920	3.2%
h	844	3.0%
Other values (49)	11736	41.4%

Common

Value	Count	Frequency (%)
	4900	71.1%
)	404	5.9%
(	404	5.9%
.	378	5.5%
'	223	3.2%
-	201	2.9%
&	86	1.2%
,	52	0.8%
2	35	0.5%
"	27	0.4%
Other values (25)	180	2.6%

Katakana

Value	Count	Frequency (%)
ト	1	12.5%
ッ	1	12.5%
ィ	1	12.5%
デ	1	12.5%
エ	1	12.5%
オ	1	12.5%
ジ	1	12.5%
ラ	1	12.5%

Hangul

Value	Count	Frequency (%)
스	1	20.0%
강	1	20.0%
남	1	20.0%
타	1	20.0%
일	1	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35191	99.9%
None	15	< 0.1%
Katakana	9	< 0.1%
Hangul	5	< 0.1%
Punctuation	3	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	4900	13.9%
e	3089	8.8%
a	2152	6.1%
o	2135	6.1%
t	1828	5.2%
i	1800	5.1%
n	1512	4.3%
r	1307	3.7%
l	997	2.8%
s	920	2.6%
Other values (73)	14551	41.3%

None

Value	Count	Frequency (%)
é	3	20.0%
ó	3	20.0%
Ø	2	13.3%
á	2	13.3%
É	1	6.7%
Ü	1	6.7%
ñ	1	6.7%
®	1	6.7%
°	1	6.7%

Punctuation

Value	Count	Frequency (%)
’	3	100.0%

Hangul

Value	Count	Frequency (%)
스	1	20.0%
강	1	20.0%
남	1	20.0%
타	1	20.0%
일	1	20.0%

Katakana

Value	Count	Frequency (%)
ト	1	11.1%
ッ	1	11.1%
ィ	1	11.1%
デ	1	11.1%
エ	1	11.1%
・	1	11.1%
オ	1	11.1%
ジ	1	11.1%
ラ	1	11.1%

duration_ms
Real number (ℝ_≥0)

Distinct	1793
Distinct (%)	89.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	228748.1245

Minimum	113000
Maximum	484146
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	113000
5-th percentile	174958.65
Q1	203580
median	223279.5
Q3	248133
95-th percentile	298857.35
Maximum	484146
Range	371146
Interquartile range (IQR)	44553

Descriptive statistics

Standard deviation	39136.56901
Coefficient of variation (CV)	0.171090229
Kurtosis	3.314898375
Mean	228748.1245
Median Absolute Deviation (MAD)	21667
Skewness	1.018924709
Sum	457496249
Variance	1531671034
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
212106	4	0.2%
240040	3	0.1%
207506	3	0.1%
202066	3	0.1%
243533	3	0.1%
268866	3	0.1%
249533	3	0.1%
236133	3	0.1%
229080	3	0.1%
199480	3	0.1%
Other values (1783)	1969	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
113000	1	0.1%
114893	1	0.1%
119133	1	0.1%
121886	1	0.1%
124055	1	0.1%
126446	1	0.1%
127920	1	0.1%
129264	1	0.1%
131064	1	0.1%
131213	1	0.1%

Value	Count	Frequency (%)
484146	1	0.1%
452906	1	0.1%
448573	1	0.1%
444333	1	0.1%
432146	1	0.1%
417920	1	0.1%
404106	1	0.1%
393813	1	0.1%
366733	1	0.1%
359973	1	0.1%

explicit
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

False	1449
True	551

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	1449	72.5%
True	551	27.6%

year
Real number (ℝ_≥0)

Distinct	23
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2009.494

Minimum	1998
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	1998
5-th percentile	2000
Q1	2004
median	2010
Q3	2015
95-th percentile	2018
Maximum	2020
Range	22
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	5.859960202
Coefficient of variation (CV)	0.002916137198
Kurtosis	-1.195355107
Mean	2009.494
Median Absolute Deviation (MAD)	5
Skewness	-0.04620500473
Sum	4018988
Variance	34.33913357
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
2012	115	5.8%
2017	111	5.5%
2001	108	5.4%
2018	107	5.3%
2010	107	5.3%
2014	104	5.2%
2005	104	5.2%
2011	99	5.0%
2016	99	5.0%
2015	99	5.0%
Other values (13)	947	47.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1998	1	0.1%
1999	38	1.9%
2000	74	3.7%
2001	108	5.4%
2002	90	4.5%
2003	97	4.9%
2004	96	4.8%
2005	104	5.2%
2006	95	4.8%
2007	94	4.7%

Value	Count	Frequency (%)
2020	3	0.1%
2019	89	4.5%
2018	107	5.3%
2017	111	5.5%
2016	99	5.0%
2015	99	5.0%
2014	104	5.2%
2013	89	4.5%
2012	115	5.8%
2011	99	5.0%

popularity
Real number (ℝ_≥0)

ZEROS

Distinct	76
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59.8725

Minimum	0
Maximum	89
Zeros	126
Zeros (%)	6.3%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	56
median	65.5
Q3	73
95-th percentile	80
Maximum	89
Range	89
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	21.33557703
Coefficient of variation (CV)	0.3563501947
Kurtosis	2.658744782
Mean	59.8725
Median Absolute Deviation (MAD)	8.5
Skewness	-1.824422019
Sum	119745
Variance	455.2068472
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	126	6.3%
69	76	3.8%
68	75	3.8%
73	69	3.5%
74	69	3.5%
67	66	3.3%
76	64	3.2%
64	63	3.1%
63	62	3.1%
72	62	3.1%
Other values (66)	1268	63.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	126	6.3%
1	31	1.6%
2	11	0.5%
3	5	0.2%
4	4	0.2%
6	1	0.1%
7	1	0.1%
8	1	0.1%
11	1	0.1%
16	1	0.1%

Value	Count	Frequency (%)
89	1	0.1%
88	1	0.1%
87	1	0.1%
86	4	0.2%
85	7	0.4%
84	11	0.5%
83	15	0.8%
82	25	1.2%
81	27	1.4%
80	43	2.1%

danceability
Real number (ℝ_≥0)

Distinct	565
Distinct (%)	28.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6674375

Minimum	0.129
Maximum	0.975
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0.129
5-th percentile	0.4199
Q1	0.581
median	0.676
Q3	0.764
95-th percentile	0.886
Maximum	0.975
Range	0.846
Interquartile range (IQR)	0.183

Descriptive statistics

Standard deviation	0.1404164146
Coefficient of variation (CV)	0.2103813684
Kurtosis	0.1255343199
Mean	0.6674375
Median Absolute Deviation (MAD)	0.091
Skewness	-0.4280298559
Sum	1334.875
Variance	0.01971676948
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.736	12	0.6%
0.688	12	0.6%
0.687	11	0.5%
0.682	11	0.5%
0.791	11	0.5%
0.66	10	0.5%
0.733	10	0.5%
0.656	10	0.5%
0.68	10	0.5%
0.794	10	0.5%
Other values (555)	1893	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.129	1	0.1%
0.177	1	0.1%
0.179	1	0.1%
0.18	1	0.1%
0.19	1	0.1%
0.209	1	0.1%
0.217	1	0.1%
0.23	1	0.1%
0.256	1	0.1%
0.259	1	0.1%

Value	Count	Frequency (%)
0.975	1	0.1%
0.97	1	0.1%
0.969	1	0.1%
0.967	1	0.1%
0.964	2	0.1%
0.963	2	0.1%
0.962	1	0.1%
0.956	1	0.1%
0.955	1	0.1%
0.951	1	0.1%

energy
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	580
Distinct (%)	29.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.720366

Minimum	0.0549
Maximum	0.999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0.0549
5-th percentile	0.44295
Q1	0.622
median	0.736
Q3	0.839
95-th percentile	0.93305
Maximum	0.999
Range	0.9441
Interquartile range (IQR)	0.217

Descriptive statistics

Standard deviation	0.1527452844
Coefficient of variation (CV)	0.2120384422
Kurtosis	0.1764537256
Mean	0.720366
Median Absolute Deviation (MAD)	0.108
Skewness	-0.6328957919
Sum	1440.732
Variance	0.02333112191
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.783	15	0.8%
0.862	12	0.6%
0.768	11	0.5%
0.8	10	0.5%
0.791	10	0.5%
0.628	9	0.4%
0.861	9	0.4%
0.786	9	0.4%
0.921	9	0.4%
0.677	9	0.4%
Other values (570)	1897	94.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0549	1	0.1%
0.0581	1	0.1%
0.115	1	0.1%
0.203	1	0.1%
0.219	1	0.1%
0.247	1	0.1%
0.249	1	0.1%
0.261	1	0.1%
0.264	1	0.1%
0.265	1	0.1%

Value	Count	Frequency (%)
0.999	1	0.1%
0.988	1	0.1%
0.985	1	0.1%
0.984	1	0.1%
0.982	1	0.1%
0.981	1	0.1%
0.979	1	0.1%
0.978	1	0.1%
0.977	2	0.1%
0.976	3	0.1%

key
Real number (ℝ_≥0)

ZEROS

Distinct	12
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.378

Minimum	0
Maximum	11
Zeros	198
Zeros (%)	9.9%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	6
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.615058827
Coefficient of variation (CV)	0.6721939062
Kurtosis	-1.297833309
Mean	5.378
Median Absolute Deviation (MAD)	3
Skewness	-0.009379280142
Sum	10756
Variance	13.06865033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	267	13.4%
11	199	10.0%
0	198	9.9%
7	197	9.8%
5	182	9.1%
8	173	8.6%
2	158	7.9%
9	157	7.8%
6	154	7.7%
10	129	6.5%
Other values (2)	186	9.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	198	9.9%
1	267	13.4%
2	158	7.9%
3	60	3.0%
4	126	6.3%
5	182	9.1%
6	154	7.7%
7	197	9.8%
8	173	8.6%
9	157	7.8%

Value	Count	Frequency (%)
11	199	10.0%
10	129	6.5%
9	157	7.8%
8	173	8.6%
7	197	9.8%
6	154	7.7%
5	182	9.1%
4	126	6.3%
3	60	3.0%
2	158	7.9%

loudness
Real number (ℝ)

HIGH CORRELATION

Distinct	1671
Distinct (%)	83.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-5.5124345

Minimum	-20.514
Maximum	-0.276
Zeros	0
Zeros (%)	0.0%
Negative	2000
Negative (%)	100.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	-20.514
5-th percentile	-8.9244
Q1	-6.49025
median	-5.285
Q3	-4.16775
95-th percentile	-2.9415
Maximum	-0.276
Range	20.238
Interquartile range (IQR)	2.3225

Descriptive statistics

Standard deviation	1.933482013
Coefficient of variation (CV)	-0.3507492041
Kurtosis	3.959788496
Mean	-5.5124345
Median Absolute Deviation (MAD)	1.1535
Skewness	-1.199866094
Sum	-11024.869
Variance	3.738352696
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6.366	5	0.2%
-5.595	4	0.2%
-5.153	4	0.2%
-3.782	4	0.2%
-5.611	3	0.1%
-5.892	3	0.1%
-4.315	3	0.1%
-3.078	3	0.1%
-5.576	3	0.1%
-4.699	3	0.1%
Other values (1661)	1965	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-20.514	1	0.1%
-17.217	1	0.1%
-15.636	1	0.1%
-14.505	1	0.1%
-13.964	1	0.1%
-13.744	1	0.1%
-13.609	1	0.1%
-13.4	1	0.1%
-13.203	1	0.1%
-13.2	1	0.1%

Value	Count	Frequency (%)
-0.276	1	0.1%
-0.74	1	0.1%
-1.131	1	0.1%
-1.19	1	0.1%
-1.203	1	0.1%
-1.231	1	0.1%
-1.299	1	0.1%
-1.357	1	0.1%
-1.538	1	0.1%
-1.569	1	0.1%

mode
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.8 KiB

1	1107
0	893

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	1107	55.4%
0	893	44.6%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
1	1107	55.4%
0	893	44.6%

Most occurring characters

Value	Count	Frequency (%)
1	1107	55.4%
0	893	44.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	1107	55.4%
0	893	44.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	1107	55.4%
0	893	44.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1107	55.4%
0	893	44.6%

speechiness
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	837
Distinct (%)	41.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1035677

Minimum	0.0232
Maximum	0.576
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0.0232
5-th percentile	0.029
Q1	0.0396
median	0.05985
Q3	0.129
95-th percentile	0.322
Maximum	0.576
Range	0.5528
Interquartile range (IQR)	0.0894

Descriptive statistics

Standard deviation	0.09615876419
Coefficient of variation (CV)	0.928462872
Kurtosis	2.626100136
Mean	0.1035677
Median Absolute Deviation (MAD)	0.02645
Skewness	1.761876968
Sum	207.1354
Variance	0.009246507931
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0432	13	0.7%
0.029	12	0.6%
0.0322	11	0.5%
0.0363	10	0.5%
0.109	9	0.4%
0.0439	9	0.4%
0.0377	8	0.4%
0.108	8	0.4%
0.046	8	0.4%
0.0431	8	0.4%
Other values (827)	1904	95.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0232	1	0.1%
0.0239	1	0.1%
0.0241	1	0.1%
0.0242	1	0.1%
0.0245	2	0.1%
0.0247	1	0.1%
0.0249	2	0.1%
0.0252	2	0.1%
0.0253	2	0.1%
0.0255	2	0.1%

Value	Count	Frequency (%)
0.576	1	0.1%
0.53	1	0.1%
0.516	1	0.1%
0.505	1	0.1%
0.488	1	0.1%
0.484	1	0.1%
0.483	1	0.1%
0.478	1	0.1%
0.47	1	0.1%
0.467	1	0.1%

acousticness
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1208
Distinct (%)	60.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.128954928

Minimum	1.92 × 10^-5
Maximum	0.976
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	1.92 × 10^-5
5-th percentile	0.0009853
Q1	0.014
median	0.0557
Q3	0.17625
95-th percentile	0.515
Maximum	0.976
Range	0.9759808
Interquartile range (IQR)	0.16225

Descriptive statistics

Standard deviation	0.1733459262
Coefficient of variation (CV)	1.34423654
Kurtosis	4.665975534
Mean	0.128954928
Median Absolute Deviation (MAD)	0.05101
Skewness	2.094133723
Sum	257.9098559
Variance	0.03004881014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.23	7	0.4%
0.107	7	0.4%
0.15	7	0.4%
0.191	6	0.3%
0.157	6	0.3%
0.102	6	0.3%
0.109	6	0.3%
0.0192	6	0.3%
0.103	6	0.3%
0.123	6	0.3%
Other values (1198)	1937	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.92 × 10^-5	1	0.1%
2.06 × 10^-5	1	0.1%
2.64 × 10^-5	1	0.1%
3.82 × 10^-5	1	0.1%
4.14 × 10^-5	1	0.1%
5.15 × 10^-5	1	0.1%
5.48 × 10^-5	1	0.1%
6.52 × 10^-5	1	0.1%
6.79 × 10^-5	1	0.1%
7.95 × 10^-5	1	0.1%

Value	Count	Frequency (%)
0.976	1	0.1%
0.966	1	0.1%
0.953	1	0.1%
0.945	1	0.1%
0.934	2	0.1%
0.932	1	0.1%
0.922	1	0.1%
0.896	1	0.1%
0.893	1	0.1%
0.883	1	0.1%

instrumentalness
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	772
Distinct (%)	38.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0152259906

Minimum	0
Maximum	0.985
Zeros	1087
Zeros (%)	54.4%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	6.83 × 10^-5
95-th percentile	0.034505
Maximum	0.985
Range	0.985
Interquartile range (IQR)	6.83 × 10^-5

Descriptive statistics

Standard deviation	0.0877707216
Coefficient of variation (CV)	5.764532757
Kurtosis	61.46993824
Mean	0.0152259906
Median Absolute Deviation (MAD)	0
Skewness	7.581735568
Sum	30.45198121
Variance	0.00770369957
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1087	54.4%
0.0013	3	0.1%
0.000108	3	0.1%
1.6 × 10^-6	3	0.1%
0.000139	3	0.1%
1.96 × 10^-6	3	0.1%
0.000113	3	0.1%
8.83 × 10^-6	3	0.1%
2.77 × 10^-6	3	0.1%
0.000157	3	0.1%
Other values (762)	886	44.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1087	54.4%
1.01 × 10^-6	1	0.1%
1.03 × 10^-6	3	0.1%
1.04 × 10^-6	1	0.1%
1.07 × 10^-6	1	0.1%
1.1 × 10^-6	1	0.1%
1.11 × 10^-6	3	0.1%
1.13 × 10^-6	1	0.1%
1.16 × 10^-6	2	0.1%
1.2 × 10^-6	1	0.1%

Value	Count	Frequency (%)
0.985	1	0.1%
0.925	1	0.1%
0.901	1	0.1%
0.894	1	0.1%
0.828	1	0.1%
0.812	1	0.1%
0.809	1	0.1%
0.799	1	0.1%
0.792	1	0.1%
0.751	1	0.1%

liveness
Real number (ℝ_≥0)

Distinct	783
Distinct (%)	39.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1812158

Minimum	0.0215
Maximum	0.853
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0.0215
5-th percentile	0.051595
Q1	0.0881
median	0.124
Q3	0.241
95-th percentile	0.4603
Maximum	0.853
Range	0.8315
Interquartile range (IQR)	0.1529

Descriptive statistics

Standard deviation	0.1406692067
Coefficient of variation (CV)	0.776252439
Kurtosis	3.831586847
Mean	0.1812158
Median Absolute Deviation (MAD)	0.05055
Skewness	1.848579144
Sum	362.4316
Variance	0.01978782572
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.104	25	1.2%
0.111	23	1.1%
0.107	20	1.0%
0.108	19	0.9%
0.118	19	0.9%
0.112	18	0.9%
0.106	17	0.9%
0.105	16	0.8%
0.101	15	0.8%
0.124	15	0.8%
Other values (773)	1813	90.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0215	1	0.1%
0.0234	1	0.1%
0.0241	1	0.1%
0.0263	1	0.1%
0.0272	1	0.1%
0.028	1	0.1%
0.0283	2	0.1%
0.0286	1	0.1%
0.0288	2	0.1%
0.029	1	0.1%

Value	Count	Frequency (%)
0.853	1	0.1%
0.843	1	0.1%
0.839	1	0.1%
0.833	1	0.1%
0.826	1	0.1%
0.82	1	0.1%
0.817	1	0.1%
0.801	1	0.1%
0.795	1	0.1%
0.775	1	0.1%

valence
Real number (ℝ_≥0)

Distinct	760
Distinct (%)	38.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.55168965

Minimum	0.0381
Maximum	0.973
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0.0381
5-th percentile	0.1739
Q1	0.38675
median	0.5575
Q3	0.73
95-th percentile	0.89505
Maximum	0.973
Range	0.9349
Interquartile range (IQR)	0.34325

Descriptive statistics

Standard deviation	0.2208641898
Coefficient of variation (CV)	0.4003413691
Kurtosis	-0.8218785176
Mean	0.55168965
Median Absolute Deviation (MAD)	0.1715
Skewness	-0.1288158625
Sum	1103.3793
Variance	0.04878099033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.418	11	0.5%
0.74	9	0.4%
0.4	8	0.4%
0.446	8	0.4%
0.801	8	0.4%
0.527	8	0.4%
0.8	7	0.4%
0.654	7	0.4%
0.352	7	0.4%
0.554	7	0.4%
Other values (750)	1920	96.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0381	1	0.1%
0.0406	1	0.1%
0.0594	1	0.1%
0.0596	1	0.1%
0.0681	1	0.1%
0.0694	1	0.1%
0.0756	1	0.1%
0.0783	1	0.1%
0.0784	1	0.1%
0.0789	1	0.1%

Value	Count	Frequency (%)
0.973	2	0.1%
0.972	2	0.1%
0.969	1	0.1%
0.968	1	0.1%
0.966	4	0.2%
0.965	3	0.1%
0.964	4	0.2%
0.963	2	0.1%
0.962	5	0.2%
0.961	4	0.2%

tempo
Real number (ℝ_≥0)

Distinct	1831
Distinct (%)	91.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120.1225575

Minimum	60.019
Maximum	210.851
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	60.019
5-th percentile	80.52815
Q1	98.98575
median	120.0215
Q3	134.2655
95-th percentile	172.09705
Maximum	210.851
Range	150.832
Interquartile range (IQR)	35.27975

Descriptive statistics

Standard deviation	26.96711199
Coefficient of variation (CV)	0.224496652
Kurtosis	0.02296970553
Mean	120.1225575
Median Absolute Deviation (MAD)	19.8895
Skewness	0.5467700722
Sum	240245.115
Variance	727.225129
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
140.022	4	0.2%
97.954	3	0.1%
83.066	3	0.1%
127.999	3	0.1%
120.003	3	0.1%
127.985	3	0.1%
121.996	3	0.1%
128.008	3	0.1%
91.03	3	0.1%
143.994	3	0.1%
Other values (1821)	1969	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
60.019	1	0.1%
62.876	1	0.1%
64.934	1	0.1%
65.043	1	0.1%
65.997	2	0.1%
68.507	1	0.1%
68.637	1	0.1%
68.942	1	0.1%
68.976	1	0.1%
70.543	1	0.1%

Value	Count	Frequency (%)
210.851	1	0.1%
205.57	1	0.1%
203.911	1	0.1%
203.862	1	0.1%
202.015	1	0.1%
201.936	1	0.1%
201.8	1	0.1%
199.958	1	0.1%
199.935	1	0.1%
199.764	1	0.1%

genre
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	59
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Memory size	15.8 KiB

pop	428
hip hop, pop	277
hip hop, pop, R&B	244
pop, Dance/Electronic	221
pop, R&B	178
Other values (54)	652

Length

Max length	37
Median length	32
Mean length	11.8785
Min length	3

Characters and Unicode

Total characters	23757
Distinct characters	35
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18 ?
Unique (%)	0.9%

Sample

1st row	pop
2nd row	rock, pop
3rd row	pop, country
4th row	rock, metal
5th row	pop

Common Values

Value	Count	Frequency (%)
pop	428	21.4%
hip hop, pop	277	13.9%
hip hop, pop, R&B	244	12.2%
pop, Dance/Electronic	221	11.1%
pop, R&B	178	8.9%
hip hop	124	6.2%
hip hop, pop, Dance/Electronic	78	3.9%
rock	58	2.9%
rock, pop	43	2.1%
Dance/Electronic	41	2.1%
Other values (49)	308	15.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pop	1633	36.4%
hip	778	17.3%
hop	778	17.3%
r&b	452	10.1%
dance/electronic	390	8.7%
rock	234	5.2%
metal	66	1.5%
latin	64	1.4%
set	22	0.5%
country	21	0.5%
Other values (7)	51	1.1%

Most occurring characters

Value	Count	Frequency (%)
p	4822	20.3%
o	3116	13.1%
	2489	10.5%
,	1704	7.2%
h	1556	6.5%
c	1467	6.2%
i	1287	5.4%
n	889	3.7%
e	886	3.7%
r	665	2.8%
Other values (25)	4876	20.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	16904	71.2%
Other Punctuation	2576	10.8%
Space Separator	2489	10.5%
Uppercase Letter	1744	7.3%
Close Punctuation	22	0.1%
Open Punctuation	22	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
p	4822	28.5%
o	3116	18.4%
h	1556	9.2%
c	1467	8.7%
i	1287	7.6%
n	889	5.3%
e	886	5.2%
r	665	3.9%
t	600	3.5%
l	573	3.4%
Other values (11)	1043	6.2%

Uppercase Letter

Value	Count	Frequency (%)
B	452	25.9%
R	452	25.9%
E	390	22.4%
D	390	22.4%
F	20	1.1%
A	20	1.1%
W	10	0.6%
T	10	0.6%

Other Punctuation

Value	Count	Frequency (%)
,	1704	66.1%
&	452	17.5%
/	420	16.3%

Space Separator

Value	Count	Frequency (%)
	2489	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	22	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	22	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18648	78.5%
Common	5109	21.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
p	4822	25.9%
o	3116	16.7%
h	1556	8.3%
c	1467	7.9%
i	1287	6.9%
n	889	4.8%
e	886	4.8%
r	665	3.6%
t	600	3.2%
l	573	3.1%
Other values (19)	2787	14.9%

Common

Value	Count	Frequency (%)
	2489	48.7%
,	1704	33.4%
&	452	8.8%
/	420	8.2%
)	22	0.4%
(	22	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	23757	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
p	4822	20.3%
o	3116	13.1%
	2489	10.5%
,	1704	7.2%
h	1556	6.5%
c	1467	6.2%
i	1287	5.4%
n	889	3.7%
e	886	3.7%
r	665	2.8%
Other values (25)	4876	20.5%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	artist	song	duration_ms	explicit	year	popularity	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	genre
0	Britney Spears	Oops!...I Did It Again	211160	False	2000	77	0.751	0.834	1	-5.444	0	0.0437	0.30000	0.000018	0.3550	0.894	95.053	pop
1	blink-182	All The Small Things	167066	False	1999	79	0.434	0.897	0	-4.918	1	0.0488	0.01030	0.000000	0.6120	0.684	148.726	rock, pop
2	Faith Hill	Breathe	250546	False	1999	66	0.529	0.496	7	-9.007	1	0.0290	0.17300	0.000000	0.2510	0.278	136.859	pop, country
3	Bon Jovi	It's My Life	224493	False	2000	78	0.551	0.913	0	-4.063	0	0.0466	0.02630	0.000013	0.3470	0.544	119.992	rock, metal
4	*NSYNC	Bye Bye Bye	200560	False	2000	65	0.614	0.928	8	-4.806	0	0.0516	0.04080	0.001040	0.0845	0.879	172.656	pop
5	Sisqo	Thong Song	253733	True	1999	69	0.706	0.888	2	-6.959	1	0.0654	0.11900	0.000096	0.0700	0.714	121.549	hip hop, pop, R&B
6	Eminem	The Real Slim Shady	284200	True	2000	86	0.949	0.661	5	-4.244	0	0.0572	0.03020	0.000000	0.0454	0.760	104.504	hip hop
7	Robbie Williams	Rock DJ	258560	False	2000	68	0.708	0.772	7	-4.264	1	0.0322	0.02670	0.000000	0.4670	0.861	103.035	pop, rock
8	Destiny's Child	Say My Name	271333	False	1999	75	0.713	0.678	5	-3.525	0	0.1020	0.27300	0.000000	0.1490	0.734	138.009	pop, R&B
9	Modjo	Lady - Hear Me Tonight	307153	False	2001	77	0.720	0.808	6	-5.627	1	0.0379	0.00793	0.029300	0.0634	0.869	126.041	Dance/Electronic

Last rows

	artist	song	duration_ms	explicit	year	popularity	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	genre
1990	Sam Smith	How Do You Sleep?	202204	False	2019	73	0.477	0.682	1	-4.931	0	0.0925	0.1530	0.000000	0.0763	0.345	110.567	pop
1991	NSG	Options	240081	True	2020	57	0.836	0.621	1	-4.684	0	0.0894	0.3890	0.000092	0.1040	0.762	101.993	World/Traditional, hip hop
1992	Normani	Motivation	193837	False	2019	71	0.599	0.887	4	-3.967	1	0.0984	0.0192	0.000001	0.3000	0.881	170.918	pop, R&B
1993	Joel Corry	Sorry	188640	False	2019	63	0.744	0.790	8	-4.617	0	0.0562	0.0547	0.000802	0.3200	0.847	125.002	pop, Dance/Electronic
1994	Post Malone	Goodbyes (Feat. Young Thug)	174960	True	2019	1	0.580	0.653	5	-3.818	1	0.0745	0.4470	0.000000	0.1110	0.175	150.231	hip hop
1995	Jonas Brothers	Sucker	181026	False	2019	79	0.842	0.734	1	-5.065	0	0.0588	0.0427	0.000000	0.1060	0.952	137.958	pop
1996	Taylor Swift	Cruel Summer	178426	False	2019	78	0.552	0.702	9	-5.707	1	0.1570	0.1170	0.000021	0.1050	0.564	169.994	pop
1997	Blanco Brown	The Git Up	200593	False	2019	69	0.847	0.678	9	-8.635	1	0.1090	0.0669	0.000000	0.2740	0.811	97.984	hip hop, country
1998	Sam Smith	Dancing With A Stranger (with Normani)	171029	False	2019	75	0.741	0.520	8	-7.513	1	0.0656	0.4500	0.000002	0.2220	0.347	102.998	pop
1999	Post Malone	Circles	215280	False	2019	85	0.695	0.762	0	-3.497	1	0.0395	0.1920	0.002440	0.0863	0.553	120.042	hip hop

Most frequently occurring

	artist	song	duration_ms	explicit	year	popularity	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	genre	# duplicates
0	Ariana Grande	Love Me Harder	236133	False	2014	74	0.472	0.714	1	-4.389	0	0.0334	0.00937	0.000000	0.0764	0.240	98.992	pop	2
1	Baby Bash	Suga Suga	239026	False	2003	73	0.662	0.748	5	-3.041	0	0.2680	0.68800	0.000008	0.0841	0.535	82.331	hip hop, pop, R&B, latin	2
2	Billie Eilish	lovely (with Khalid)	200185	False	2018	86	0.351	0.296	4	-10.109	0	0.0333	0.93400	0.000000	0.0950	0.120	115.284	pop, Dance/Electronic	2
3	Bruno Mars	Locked out of Heaven	233478	False	2012	85	0.726	0.698	5	-4.165	1	0.0431	0.04900	0.000000	0.3090	0.867	143.994	pop	2
4	Bryson Tiller	Don't	198293	True	2015	78	0.765	0.356	11	-5.556	0	0.1950	0.22300	0.000000	0.0963	0.189	96.991	hip hop, pop, R&B	2
5	Busta Rhymes	I Know What You Want (feat. Flipmode Squad)	324306	True	2002	68	0.648	0.759	6	-4.315	1	0.3060	0.01420	0.000000	0.6480	0.518	85.996	hip hop, pop	2
6	Chris Brown	Kiss Kiss (feat. T-Pain)	250666	False	2007	68	0.729	0.658	10	-3.386	0	0.2250	0.05060	0.000000	0.0693	0.551	140.043	hip hop, pop, R&B	2
7	Coldplay	Clocks	307879	False	2002	79	0.577	0.749	5	-7.215	0	0.0279	0.59900	0.011500	0.1830	0.255	130.970	rock, pop	2
8	Coldplay	Paradise	278719	False	2011	82	0.449	0.585	5	-6.761	1	0.0268	0.05090	0.000087	0.0833	0.212	139.631	rock, pop	2
9	Craig David	Fill Me In	257200	False	2000	60	0.682	0.744	8	-6.981	1	0.0365	0.37600	0.009510	0.0600	0.827	132.493	hip hop, pop, R&B	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Currency Symbol

Math Symbol

Final Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Other Letter

Decimal Number

Close Punctuation

Open Punctuation

Other Symbol

Space Separator

Dash Punctuation

Currency Symbol

Final Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Katakana

Hangul

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Hangul

Katakana

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Close Punctuation

Open Punctuation